#!usr/bin/env python  
# -*- coding:utf-8 _*-
""" 
@author:robot
@file: mysql01.py 
@version:
@time: 2022/01/17 
"""
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import MYSQL01_TYPE
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import generate_columns_data

MYSQL01_COLUMNS = MYSQL01_TYPE.get('COLUMNS')
BASE = MYSQL01_COLUMNS.get('BASE')
PK = BASE.get('PK')
NO_PK = BASE.get('NO PK')

# ****STRING****
STRING = MYSQL01_COLUMNS.get('STRING')

# ****NUMERIC****
NUMERIC = MYSQL01_COLUMNS.get('NUMERIC')

# DATE_TIME
DATE_TIME = MYSQL01_COLUMNS.get('DATE/TIME')

# SPATIAL_DATA
SPATIAL_DATA = MYSQL01_COLUMNS.get('SPATIAL DATA TYPES')

# JSON
JSON = MYSQL01_COLUMNS.get('JSON').get('CREATE')

# --STRING--
CHAR = STRING.get('CHAR').get('CREATE')
VARCHAR = STRING.get('VARCHAR').get('CREATE')
BINARY = STRING.get('BINARY').get('CREATE')
VARBINARY = STRING.get('VARBINARY').get('CREATE')
TINYBLOB = STRING.get('TINYBLOB').get('CREATE')
BLOB = STRING.get('BLOB').get('CREATE')
MEDIUMBLOB = STRING.get('MEDIUMBLOB').get('CREATE')
LONGBLOB = STRING.get('LONGBLOB').get('CREATE')
TINYTEXT = STRING.get('TINYTEXT').get('CREATE')
TEXT = STRING.get('TEXT').get('CREATE')
MEDIUMTEXT = STRING.get('MEDIUMTEXT').get('CREATE')
LONGTEXT = STRING.get('LONGTEXT').get('CREATE')
ENUM = STRING.get('ENUM').get('CREATE')
SET = STRING.get('SET').get('CREATE')

# --NUMERIC--
BIT = NUMERIC.get('BIT').get('CREATE')
TINYINT = NUMERIC.get('TINYINT').get('CREATE')
TINYINT_UNSIGNED = NUMERIC.get('TINYINT UNSIGNED').get('CREATE')
BOOL = NUMERIC.get('BOOL').get('CREATE')
BOOLEAN = NUMERIC.get('BOOLEAN').get('CREATE')
SMALLINT = NUMERIC.get('SMALLINT').get('CREATE')
SMALLINT_UNSIGNED = NUMERIC.get('SMALLINT UNSIGNED').get('CREATE')
MEDIUMINT = NUMERIC.get('MEDIUMINT').get('CREATE')
MEDIUMINT_UNSIGNED = NUMERIC.get('MEDIUMINT UNSIGNED').get('CREATE')
INT = NUMERIC.get('INT').get('CREATE')
INT_UNSIGNED = NUMERIC.get('INT UNSIGNED').get('CREATE')
BIGINT = NUMERIC.get('BIGINT').get('CREATE')
BIGINT_UNSIGNED = NUMERIC.get('BIGINT UNSIGNED').get('CREATE')
DECIMAL = NUMERIC.get('DECIMAL').get('CREATE')
DECIMAL_UNSIGNED = NUMERIC.get('DECIMAL UNSIGNED').get('CREATE')
FLOAT = NUMERIC.get('FLOAT').get('CREATE')
FLOAT_UNSIGNED = NUMERIC.get('FLOAT UNSIGNED').get('CREATE')
DOUBLE = NUMERIC.get('DOUBLE').get('CREATE')
DOUBLE_UNSIGNED = NUMERIC.get('DOUBLE UNSIGNED').get('CREATE')
# --DATE/TIME--
DATE = DATE_TIME.get('DATE').get('CREATE')
DATETIME57 = DATE_TIME.get('DATETIME57').get('CREATE')
DATETIME = DATE_TIME.get('DATETIME').get('CREATE')
TIMESTAMP57 = DATE_TIME.get('TIMESTAMP57').get('CREATE')
TIMESTAMP = DATE_TIME.get('TIMESTAMP').get('CREATE')
TIME57 = DATE_TIME.get('TIME57').get('CREATE')
TIME = DATE_TIME.get('TIME').get('CREATE')
YEAR = DATE_TIME.get('YEAR').get('CREATE')
YEAR2 = DATE_TIME.get('YEAR(2)').get('CREATE')

# --SPATIAL DATA TYPES--
GEOMETRY = SPATIAL_DATA.get('GEOMETRY')
POINT = SPATIAL_DATA.get('POINT')
LINESTRING = SPATIAL_DATA.get('LINESTRING')
POLYGON = SPATIAL_DATA.get('POLYGON')
MULTIPOINT = SPATIAL_DATA.get('MULTIPOINT')
MULTILINESTRING = SPATIAL_DATA.get('MULTILINESTRING')
MULTIPOLYGON = SPATIAL_DATA.get('MULTIPOLYGON')
GEOMETRYCOLLECTION = SPATIAL_DATA.get('GEOMETRYCOLLECTION')
